CountColumnCells_2Criteria

Counts how many cells matching 2 criterias. Just like

MatchIf2Up

Search for 2 items in 2 columns starting from last row upword (Starting with ...

MatchIfUp or MatchIfRev

Searching for an item in a column from bottom to top. Will search for item in ...

Concatenate_HTMLColumn

Build a string from a certain column in html table (using < table, < tr, and < ...

gsplit usage

How to use gsplit to split large files into smaller parts to allow to read it. ...

GSplitPDF.zip

SQL instr

Searching for a string inside a string in SQL. You may say it is the instr in ...

VBInstrRev

Similar to VBInstr, but this one does it in reverse, which is instrrev() ...

Grandchildren files and count

Returns list of files in 2 level folders Will not find files as children of ...

SearchinHTMLTable

Search for a word in a certain column in html table and return the full row ...

Times_inHours

Calculate the total number of hours between two times and return in format ...

SubZero

Forces Excel to not convert numbers during moving them across sheets, or ...

ScrapeURL_ToSheet

Reads content of Page from URL to a sheet. This was made specially for certain ...